from sqlalchemy import Column, Integer, String, DateTime
from module_admin.entity.do.base import db


class CourseContent(db.Model):
    __tablename__ = 'sys_course_content'

    id = Column(Integer, primary_key=True, autoincrement=True, comment='内容ID')
    content_type = Column(String(50), nullable=False)  # e.g. 'video', 'pdf'
    content_url = Column(String(255), nullable=False)  # 文件存储路径或URL
    uploaded_by = Column(String(64, collation='utf8_general_ci'), default='', comment='上传者')
    course_id = Column(Integer, comment='课程ID')
